SELECT
    i_tm.itemid          item_id,
    i_tm.itemstring      item_name,
    i_tm.itemtype        item_type,
    i_un.id              units_id,
    i_un.itemunit    	 units_name,
    i_un.quantity        units_quan,
    i_un.Barcode     	 units_barcode,
    i_pr.sellprice   	 units_sell,
    i_pr.buyprice    	 units_buy
FROM   itemunitequivalent i_un
JOIN   items              i_tm ON i_tm.itemid     = i_un.theitemid
JOIN   itemsprices        i_pr ON i_pr.itemid     = i_tm.itemid
JOIN   itemstypes         i_ty ON i_ty.itemtypeid = i_tm.itemtype
WHERE  i_un.itemunit = i_pr.itemunit
  AND  i_pr.pricelistid = @pl